﻿using SQLServer.DBUtility;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Tenancy.Helper;

namespace Tenancy
{
    public partial class index : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string a = DESEncrypt.MD5Encrypt("18501533193");
            string b = DESEncrypt.MD5Encrypt("MIICeAIBADANBgkqhkiG9w0BAQEFAASCAmIwggJeAgEAAoGBAOup55rex/LeE/ZO18501533193");
         //Helper.MsgSend.HB_SendMsg("18551127295", "【利星行机械】你的验证码为456235");
            string strcgs = string.Format("select * from Hbung_CompanyInfo where CellTel='18551127295'");
            DataTable mydata = DBHelpSQL.Query(strcgs).Tables[0];
            if(mydata!=null&&mydata.Rows.Count>0)
            {
                cgs_uu.Text = "本地数据库连接成功";
            }
            else
            {
                cgs_uu.Text = "本地数据库连接成功";
            }

            string strcgsss = string.Format("select * from View_DeviceDetail ");
            DataTable mydataeee = DbLocalSQL.Query(strcgsss).Tables[0];
            if (mydataeee != null && mydataeee.Rows.Count > 0)
            {
                sxm_uu.Text = "test数据库连接成功";
            }
            else
            {
                sxm_uu.Text = "test数据库连接成功";
            }
        }
    }
}